package com.codinghero.zqlb.spider.dao;

import java.sql.SQLException;
import java.util.List;

import com.codinghero.zqlb.match.LiveChannel;

public class LiveChannelDao extends BaseDao {
	public List<LiveChannel> getAllLiveChannels() throws SQLException {
		return dbOper.selectList(
						"SELECT lc.channelId, lc.liveSiteId, c.name as channelName, l.name as liveSiteName, lc.url "
								+ " FROM zqlb_channel c, zqlb_live_channel lc, zqlb_live_site l "
								+ " WHERE c.id=lc.channelId AND lc.liveSiteId=l.id ",
						LiveChannel.class);
	}
}
